package com.addplus.townmall.server.api.mapper.town;

import com.addplus.townmall.server.api.model.town.StoreShopManager;
import com.addplus.townmall.server.api.model.town.expand.ShopManagerExpand;
import com.addplus.townmall.server.api.utils.BaseAddMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 商家店铺管理员 Mapper 接口
 * </p>
 *
 * @author zhangjiehang
 * @since 2018-10-27
 */
public interface StoreShopManagerMapper extends BaseAddMapper<StoreShopManager> {
    @Select("SELECT s.id,s.store_id,d.store_name,s.account,s.nick_name,s.`password`,s.phone,s.gmt_modified FROM store_shop_manager s ,store d WHERE s.store_id=d.id AND s.is_deleted=0")
    List<ShopManagerExpand> getAllShopMannger(IPage page);
}
